USE [OWNX]
GO
/****** Object:  Table [dbo].[BEFEKTETESEK]    Script Date: 08/04/2008 18:25:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BEFEKTETESEK](
	[BFT_ID] [int] IDENTITY(1,1) NOT NULL,
	[BFT_PRT_ID] [int] NULL,
	[BFT_TIPUS] [varchar](5) COLLATE SQL_Hungarian_CP1250_CS_AS NOT NULL,
	[BFT_BANK_INT_ID] [int] NULL,
	[BFT_BANK_NEV] [varchar](100) COLLATE SQL_Hungarian_CP1250_CS_AS NULL,
	[BFT_BANK_KARTYA] [varchar](1) COLLATE SQL_Hungarian_CP1250_CS_AS NULL,
	[BFT_BANK_KFAJTA] [int] NULL,
	[BFT_BANK_KTIPUS] [int] NULL,
	[BFT_BANK_KMIRE] [varchar](200) COLLATE SQL_Hungarian_CP1250_CS_AS NULL,
	[BFT_TOZSD_VANE] [varchar](1) COLLATE SQL_Hungarian_CP1250_CS_AS NULL,
	[BFT_TOZSD_MAGYAR] [varchar](1) COLLATE SQL_Hungarian_CP1250_CS_AS NULL,
	[BFT_TOZSD_OSSZEG] [money] NULL,
	[BFT_TOZSD_TELJ] [money] NULL,
	[BFT_BEFAL_VANE] [varchar](1) COLLATE SQL_Hungarian_CP1250_CS_AS NULL,
	[BFT_BEFAL_MAGYAR] [varchar](1) COLLATE SQL_Hungarian_CP1250_CS_AS NULL,
	[BFT_BEFAL_OSSZEG] [money] NULL,
	[BFT_BEFAL_TELJ] [money] NULL,
	[BFT_BANKB_INT_ID] [int] NULL,
	[BFT_BANKB_OSSZEG] [money] NULL,
	[BFT_BANKB_KAMAT] [money] NULL,
	[BFT_EGYEB_MEGJ] [varchar](500) COLLATE SQL_Hungarian_CP1250_CS_AS NULL,
	[BFT_EGYEB_FUNDAMENTA] [nchar](1) COLLATE SQL_Hungarian_CP1250_CS_AS NULL,
	[BFT_EGYEB_FUTAMIDO] [int] NULL,
	[BFT_EGYEB_OSSZEG] [money] NULL,
	[BFT_CREATED] [datetime] NULL,
	[BFT_CREATED_BY] [int] NULL,
	[BFT_MODIFIED] [datetime] NULL,
	[BFT_MODIFIED_BY] [int] NULL,
 CONSTRAINT [PK_BEFEKTETESEK] PRIMARY KEY CLUSTERED 
(
	[BFT_ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF